<?php
$pageSize = 3;
$pageIndex = isset($_GET["pageIndex"])?$_GET["pageIndex"]:1;
$pageCount = 0;
$startRow = ($pageIndex-1)*$pageSize;


$sql = "select * from `article`";
$where = "";

$queryTitle = isset($_GET["Title"])?$_GET["Title"]:null;
if($queryTitle){
    $where .= " Title like ('%$queryTitle%')";
}

$queryAuthor = isset($_GET["Author"])?$_GET["Author"]:null;
if($queryAuthor){
    if($where) $where .=" AND ";
    $where .= " AuthorName like ('%$queryAuthor%')";
}
$queryMinDate = isset($_GET["minDate"])?$_GET["minDate"]:null;
if($queryMinDate){
    if($where) $where .=" AND ";
    $where .= " CreateTime <= '$queryMinDate'";
}

$queryMaxDate = isset($_GET["maxDate"])?$_GET["maxDate"]:null;
if($queryMaxDate){
    if($where) $where .=" AND ";
    $where .= " CreateTime >= '$queryMaxDate'";
}



if($where) $sql .= " WHERE $where";



$conn = new mysqli("localhost","root","","myblog");
$rows = [];
$sql .=" LIMIT $startRow,$pageSize";
echo $sql;
$rs = $conn->query($sql);
if($conn->error) die($conn->error);
while($row = $rs->fetch_assoc()){
    $rows[] = $row;
}
$rs->close();

$total = 0;
$sql = "SELECT count(Id) as t FROM `article`";
if($where) $sql .= " WHERE $where";

$rs = $conn->query($sql);
$total = $rs->fetch_assoc()["t"];
$pageCount = ceil($total/$pageSize);


function makePageUrl($pageIndex){
    $querystring= "pageIndex=$pageIndex";
    foreach($_GET as $k=>$v){
        if($k==="pageIndex") continue;
        $querystring.="&$k=$v";
    }
    return $querystring;
}


?>

<!DOCTYPE html>
<html>
<head>
    <meta http-equiv="content-type" content="text/html;charset=UTF-8" />  
    <title>第一个网页</title>
</head>
<body>
   <h3>文章列表</h3>
   <a href="article_add.php">新建文章</a>

   <form action="" method="GET">
   <div>
        <label>标题</label>
        <input type="text" name="Title" id="Title" value="<?=$queryTitle?>" />
    </div>
    <div>
        <label>作者</label>
        <input type="text" name="Author" id="Title" value="<?=$queryAuthor?>" />
    </div>
    <div>
        <label>时间</label>
        <input type="text" name="minDate"  value="<?=$queryMinDate?>" />
        <input type="text" name="maxDate" value="<?=$queryMaxDate?>" />
    </div>
   
          <input type="submit" name="submit" value="搜索" />
   </form>
    <table border="1">
        <thead>
            <tr>
                <th>标题</th>
                <th>作者</th>
                <th>时间</th>
                <th>操作</th>
            </tr> 
        </thead>
        <tbody>
            <?php foreach($rows as $row){?>
                <tr>
                <td>
                   <?=$row["Title"]?>
                </td>
                <td>
                    <?=$row["AuthorName"]?>
                </td>
                <td> 
                    <?=$row["UpdateTime"]?><br />
                    <?=$row["CreateTime"]?>
                </td>
                <td>
                    详细 修改 删除
                </td>
            </tr>

           <?php } ?>
            
        </tbody>
        <tfoot>
            <tr>
                <td colspan="4">
                共<?=$total ?>条记录，<?=$pageCount?>页当前为第<input type='text' value="2" value="<?=$pageIndex?>" />页，
                    <a href="list.php?pageIndex=1&Title=<?=$queryTitle?>&Author=<?=$queryAuthor?>">首页</a> <
                        <?php for($i =1;$i<=$pageCount;$i++) {?>
                            <a href="list.php?pageIndex=<?=$i?>&Title=<?=$queryTitle?>&Author=<?=$queryAuthor?>"><?=$i ?></a>
                        <?php } ?>
                        >
                      <a href="list.php?pageIndex=<?=$pageCount?>&Title=<?=$queryTitle?>&Author=<?=$queryAuthor?>">尾页</a>
                </td>
            </tr>
        </tfoot>
    </table>
</body>
</html>